package org.springblade.modules.admin.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Select;
import org.springblade.modules.admin.entity.UserExt;
import org.springblade.modules.admin.vo.TlwEstatePeopleVO;

import java.util.List;

public interface UserExtMapper extends BaseMapper<UserExt> {
	@Select("SELECT u.id,u.real_name AS realName,u.phone FROM blade_user_ext ue LEFT JOIN blade_user u ON ue.user_id=u.id WHERE ue.estate_company_id IS NOT NULL AND u.is_deleted=0 AND u.`status`=1")
    List<TlwEstatePeopleVO> estatePeopleList();

	List<String> getLarkIdByElevatorId(Long elevatorId);
}
